package com.cloud.check.api.mapper;

import com.cloud.check.api.bean.JgJgdxGthBasicMsgBean;
import com.cloud.check.api.entity.JgJgdxGthBasicMsg;
import com.cloud.check.common.utils.BaseMapperHelper;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * 
 * JgJgdxGthBasicMsgMapper数据库操作接口类
 * 
 **/

public interface JgJgdxGthBasicMsgMapper extends BaseMapperHelper<JgJgdxGthBasicMsg> {
    @Select("select PRIPID,RegNO,UniSCID,TraName,EntType,EntType_CN,Name,OpLoc,OpScope,CompForm,CompForm_CN,RegOrg,RegOrg_CN,LinkmanName,LinkmanPhone" +
            " from `check`.`jg_jgdx_gth_basic_msg`")
    @Results({@Result(property = "pripID", column = "PRIPID",javaType = String.class),
            @Result(property="regNO", column="RegNO"),
            @Result(property="uniSCID", column="UniSCID"),
            @Result(property="traName", column="TraName"),
            @Result(property="entType" ,column="EntType" ),
            @Result(property="entTypeCN", column="EntType_CN" ),
            @Result(property="name", column="Name" ),
            @Result(property="opLoc", column="OpLoc" ),
            @Result(property="opScope", column="OpScope" ),
            @Result(property="compForm", column="CompForm" ),
            @Result(property="compFormCN", column="CompForm_CN" ),
            @Result(property="regOrg" ,column="RegOrg" ),
            @Result(property="regOrgCN", column="RegOrg_CN" ),
            @Result(property="regState" ,column="RegState" ),
            @Result(property="regStateCN", column="RegState_CN" ),
            @Result(property="estDate", column="EstDate" ),
            @Result(property="apprDate" ,column="ApprDate" ),
            @Result(property="revDate", column="RevDate" ),
            @Result(property="sugRevReason" ,column="SugRevReason" ),
            @Result(property="operatingLongitude", column="Operating_Longitude" ),
            @Result(property="operatingLatitude" ,column="Operating_Latitude" ),
            @Result(property="linkmanName", column="LinkmanName" ),
            @Result(property="linkmanCerNO" ,column="LinkmanCerNO" ),
            @Result(property="linkmanPhone", column="LinkmanPhone" ),
            @Result(property="cdTime", column="cd_time" ),
            @Result(property="cdSource" ,column="cd_source" ),
            @Result(property="cdOperation", column="cd_operation" ),
            @Result(property="cdId", column="cd_id" ),
            @Result(property="cdBatch" ,column="cd_batch" )})
    List<JgJgdxGthBasicMsg> findAllBusiness();
}